﻿using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Configuration;
using DAL;
using Common;


public partial class User_KaoQin : System.Web.UI.Page
{
    protected string MenuType
    {
        get { return string.IsNullOrEmpty(Request["menutype"]) ? "" : Request["menutype"].ToString(); }
    }

    protected void Page_PreRender(object sender, EventArgs e)
    {
            OneDate.Attributes.Add("onclick","selectDate(this);");
            TwoDate.Attributes.Add("onclick", "selectDate(this);");


            if (!this.IsPostBack)
            {
                IList<Sys_Account> UserList = new Account().GetNotAccount(1);
                foreach (Sys_Account account in UserList)
                    MUserKey.Items.Add(new ListItem("◆ " + account.RealName, account.UserKey.ToString()));
            }

           

            //条件 Hashtable

            Hashtable tb = new Hashtable();
            bool QueryAdd = false;

            if (!string.IsNullOrEmpty(MUserKey.SelectedValue))
            {
                tb.Add("MUserKey", MUserKey.SelectedValue);
                QueryAdd = true;
            }
            if (!string.IsNullOrEmpty(Keyword.Text.Trim()))
            {
                tb.Add("Keyword", Keyword.Text.Trim());
                QueryAdd = true;
            }
            if (OneDate.Text.Trim() != "选择开始日期")
            {
                tb.Add("OneDate", OneDate.Text.Trim());
                QueryAdd = true;
            }
            if (TwoDate.Text.Trim() != "选择结束日期")
            {
                tb.Add("TwoDate", TwoDate.Text.Trim());
                QueryAdd = true;
            }
            tb = QueryAdd ? tb : null;

            KqDataBind(tb);
    }

    private void KqDataBind(Hashtable QueryTable)
    {
        lv_KaoQin.DataSource = new KaoQin().SelectKaoQin(QueryTable);
        lv_KaoQin.DataBind();

        if (DataPager1.TotalRowCount == 0)
            DataPager1.Visible = false;
    }

    //搜索
    protected void submit_Click(object sender, EventArgs e)
    {
        Hashtable tb = new Hashtable();
        bool QueryAdd = false;

        //条件 Hashtable
      
        if (!string.IsNullOrEmpty(MUserKey.SelectedValue))
        {
            tb.Add("MUserKey", MUserKey.SelectedValue);
            QueryAdd = true;
        }
        if (!string.IsNullOrEmpty(Keyword.Text.Trim()))
        {
            tb.Add("Keyword", Keyword.Text.Trim());
            QueryAdd = true;
        }
        if (OneDate.Text.Trim() != "选择开始日期")
        {
            tb.Add("OneDate", OneDate.Text.Trim());
            QueryAdd = true;
        }
        if (TwoDate.Text.Trim() != "选择结束日期")
        {
            tb.Add("TwoDate", TwoDate.Text.Trim());
            QueryAdd = true;
        }
        tb = QueryAdd ? tb : null;

        KqDataBind(tb);
    }

    //DropDownList绑定
    protected void lv_KaoQin_DataBound(object sender, EventArgs e)
    {   
      
        //分页下拉框
        DropDownList pagelist = (DropDownList)DataPager1.Controls[4].FindControl("PageList");

        int CurPage = WebUtility.GetCurrentPage(DataPager1.StartRowIndex, DataPager1.PageSize);
        int TotalPage = WebUtility.GetTotalPage(DataPager1.TotalRowCount, DataPager1.PageSize);
        for (int i = 1; i <= TotalPage; i++)
            pagelist.Items.Add(new ListItem("第" + i.ToString() + "页", i.ToString()));
        pagelist.SelectedValue = CurPage.ToString();
    }

    //DropDownList分页选择
    protected void PageList_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList pagelist = (DropDownList)sender;

        int CurPage = Convert.ToInt32(pagelist.SelectedValue);
        int TotalPage = WebUtility.GetTotalPage(DataPager1.TotalRowCount, DataPager1.PageSize);

        DataPager1.SetPageProperties( (CurPage-1)*DataPager1.PageSize,DataPager1.PageSize,true);
    }

    //删除
    protected void lv_KaoQin_ItemCommand(object sender, ListViewCommandEventArgs e)
    {
        if (e.CommandName == "del")
        { 
            int KqKey = Convert.ToInt32(e.CommandArgument);

            new KaoQin().DelKaoQin(KqKey);
        }
    }

    //Export
    protected void submit0_Click(object sender, EventArgs e)
    {
        //条件 Hashtable

        Hashtable tb = new Hashtable();
        bool QueryAdd = false;

        if (!string.IsNullOrEmpty(MUserKey.SelectedValue))
        {
            tb.Add("MUserKey", MUserKey.SelectedValue);
            QueryAdd = true;
        }
        if (!string.IsNullOrEmpty(Keyword.Text.Trim()))
        {
            tb.Add("Keyword", Keyword.Text.Trim());
            QueryAdd = true;
        }
        if (OneDate.Text.Trim() != "选择开始日期")
        {
            tb.Add("OneDate", OneDate.Text.Trim());
            QueryAdd = true;
        }
        if (TwoDate.Text.Trim() != "选择结束日期")
        {
            tb.Add("TwoDate", TwoDate.Text.Trim());
            QueryAdd = true;
        }
        tb = QueryAdd ? tb : null;

        KaoQin.DataToExcel(tb);
    }
}
